﻿<?xml version="1.0" encoding="utf-8"?>
<AdoNetDataAccess connection="$ArticleDBConnection$" formatter="bizobjlist of eComSalesOrderHandlingFee">
	<Sql>
		SELECT        
			hf.id, hf.companyId, shippingProviderId as provider_id, deliveryMethodName, baseFee, percentCost, bizRuleCalculator,
			dp.name as provider_name
		FROM
			eComCompanyHandlingFees AS hf
			JOIN eComDeliveryProviders AS dp ON hf.shippingProviderId = dp.id
		WHERE
			(hf.companyId = @companyId) 
		order by 
			dp.name, hf.deliveryMethodName
	</Sql>
	<Param name="companyId" type="UniqueIdentifier"/>
</AdoNetDataAccess>
